Sr. BI Developer
Onsite in Dallas with Occasional Travel to manufacturing sites
Up to $165K + Benefits
Our client is modernizing their data platform and data visualization strategies from a traditional solution (SQL Server, SSIS, and Tableau) to a more modern cloud data platform using Azure SQL Managed Instance and Microsoft Fabric.
The ideal candidate will play a key role in orchestrating the transition to a modern data platform, have a deep technical understanding of Power BI and possess strong business acumen to translate customer use cases into compelling and efficient visualization designs. This role will drive innovation, enhance user experience, and enable data democratization across the organization.
Required Qualifications:
- Around 8 years of relevant experience in data platform engineering, data visualization, and business intelligence.
- Extensive experience with Power BI, including architecture, data modeling, CI/CD pipelines, security, and design principles.
- Deep understanding of Power BI dashboard development, data visualization, ETL processes, data architecture, and data modeling.
- Experience implementing advanced techniques using Power BI Premium, XMLA Endpoints, and Tabular Editor 3
- Strong knowledge of Azure SQL Database, Azure SQL Managed Instance, On-Premise SQL Server, and Azure DevOps.
- Strong analytical and problem-solving skills, with the ability to think critically and handle complex data challenges.
- Excellent verbal and written communication skills, with the ability to effectively collaborate with both business and technical teams.
- Proven experience working in a fast-paced, team-oriented, and collaborative environment.
Preferred Qualifications:
- Familiarity with Azure Data Factory, Azure Synapse, and SSIS.
- Experience with Azure Data Lake and API-based data integration.
- Experience working with manufacturing data and familiarity with D365 Finance and Operations data structures.
- Knowledge of cloud data architecture and modern data pipeline design principles.
Key Responsibilities
Collaboration
- Collaborate with subject matter experts, often in ambiguous situations, to determine business information and reporting requirements.
- Foster improved alignment of technology initiatives with business strategies by building and maintaining relationships with technology teams and business partners.
- Provide technical and architectural guidance to projects and teams to ensure effective reporting and analyses.
Data Visualization and Administration
- Define, design, develop, document, and maintain Power BI data models and visualizations.
- Implement advanced techniques using Power BI Premium, XMLA Endpoints, and Tabular Editor 3 to elevate our analytics capabilities.
- Develop and maintain complex DAX, Power Query formula language (M), and T-SQL queries.
- Stay ahead of data science trends and emerging tools and technologies to continually enhance frameworks, processes, and best practices.
- Provide guidance on Power BI security, user mapping, and app deployment.
- Maintain adherence to security and architectural standards as well as usability design principles.
Data Engineering
- Work with various data sources such as SQL Server, DataVerse, Excel, Azure SQL, SharePoint Lists/Libraries, API based data, and unstructured data.
- Oversee and conduct analysis, design, implementation, and support of the company data warehouse which may include developing ETL routines using appropriate tools
- Stay informed about new developments and technologies through continuous learning, industry publications, vendor contacts, trainings, etc.
